﻿alter table logodetaildetail
add ThumbnailUrl varchar(250) null
Go



alter PROCEDURE [dbo].[SP_LogoDetailDetailInsert]  

 @LogoDetailId int   

           ,@OrderNo int  

           ,@FileName varchar(200) ,

           @Description varchar(500),

		   @Script varchar(max),

           

           @MenuId int ,
		   @ThumbnailUrl varchar(250)

AS  

BEGIN  

 INSERT INTO [dbo].[LogoDetailDetail]  

           ([LogoDetailId]  

           ,[OrderNo]  

           ,[FileName],

           ThumbnailUrl ,

           [Description],

		  Scripts,

           MenuId)  

     VALUES  

           (@LogoDetailId  

           ,@OrderNo  

           ,@FileName,

           @ThumbnailUrl ,

           @Description,

		   @Script,

           @MenuId)  

  

  

END 

GO

Update tblSitePages set PageName='Mapping' where PageId='38'
Update tblSitePages set PageName='NewsWeek' where PageId='36'